﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

/// <summary>
///DDLManage 的摘要说明
/// </summary>
public class DDLManage
{
  public DDLManage()
  {
    //
    //TODO: 在此处添加构造函数逻辑
    //
  }

  //public static void BindYQXZ(CheckBoxList ddl, string sID)
  //{
  //  ListItem li = null;
  //  string sSql = "select a.yqxzid,a.yqxz,(case when b.khid is null then 'false' else 'true' end) qx from jcxx_yqxz a left join jcxx_khyqxz b on a.yqxzid=b.yqxzid and b.khid=@0";
  //  SqlParameter[] cmdParams = new SqlParameter[1] { new SqlParameter("@0", SqlDbType.VarChar, 20) };
  //  cmdParams[0].Value = sID;
  //  SqlDataReader dr = DbHelperSQL.ExecuteReader(sSql, cmdParams);
  //  while (dr.Read())
  //  {
  //    li = new ListItem();
  //    li.Text = dr["yqxz"].ToString();
  //    li.Value = dr["yqxzid"].ToString();
  //    li.Selected = Convert.ToBoolean(dr["qx"].ToString());
  //    ddl.Items.Add(li);
  //  }
  //  dr.Close();
  //}
}
